﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="GarziESRPDataSet" targetNamespace="http://tempuri.org/GarziESRPDataSet.xsd" xmlns:mstns="http://tempuri.org/GarziESRPDataSet.xsd" xmlns="http://tempuri.org/GarziESRPDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ESRPConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ESRPConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ResUma.Properties.Settings.GlobalReference.Default.ESRPConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AngajatiSalarizareTableAdapter" GeneratorDataComponentClassName="AngajatiSalarizareTableAdapter" Name="AngajatiSalarizare" UserDataComponentName="AngajatiSalarizareTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.AngajatiSalarizare" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[AngajatiSalarizare] WHERE (([IDAngajatSalarizare] = @Original_IDAngajatSalarizare) AND ([IdPersoana] = @Original_IdPersoana) AND ([DeLaData] = @Original_DeLaData) AND ([Salar] = @Original_Salar) AND ([IDDepartament] = @Original_IDDepartament) AND ([IdTipGrad] = @Original_IdTipGrad) AND ([OreNorma] = @Original_OreNorma) AND ([FractiuneNorma] = @Original_FractiuneNorma) AND ((@IsNull_PanaLaData = 1 AND [PanaLaData] IS NULL) OR ([PanaLaData] = @Original_PanaLaData)) AND ([NormaBaza] = @Original_NormaBaza) AND ((@IsNull_ServiciiPeChitanta = 1 AND [ServiciiPeChitanta] IS NULL) OR ([ServiciiPeChitanta] = @Original_ServiciiPeChitanta)) AND ([CodUnitate] = @Original_CodUnitate) AND ([Clasa] = @Original_Clasa) AND ((@IsNull_Grupa = 1 AND [Grupa] IS NULL) OR ([Grupa] = @Original_Grupa)) AND ((@IsNull_IDJurnal = 1 AND [IDJurnal] IS NULL) OR ([IDJurnal] = @Original_IDJurnal)) AND ([SalarFunctie] = @Original_SalarFunctie) AND ((@IsNull_Marca = 1 AND [Marca] IS NULL) OR ([Marca] = @Original_Marca)) AND ((@IsNull_NrContract = 1 AND [NrContract] IS NULL) OR ([NrContract] = @Original_NrContract)) AND ((@IsNull_DataContract = 1 AND [DataContract] IS NULL) OR ([DataContract] = @Original_DataContract)) AND ((@IsNull_TipContract = 1 AND [TipContract] IS NULL) OR ([TipContract] = @Original_TipContract)) AND ((@IsNull_PerioadaDeterminata = 1 AND [PerioadaDeterminata] IS NULL) OR ([PerioadaDeterminata] = @Original_PerioadaDeterminata)) AND ((@IsNull_Observatii = 1 AND [Observatii] IS NULL) OR ([Observatii] = @Original_Observatii)) AND ((@IsNull_DurataContract = 1 AND [DurataContract] IS NULL) OR ([DurataContract] = @Original_DurataContract)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDAngajatSalarizare" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAngajatSalarizare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdPersoana" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdPersoana" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DeLaData" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DeLaData" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Salar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Salar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDDepartament" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDDepartament" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdTipGrad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipGrad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_OreNorma" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="OreNorma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_FractiuneNorma" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="FractiuneNorma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PanaLaData" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PanaLaData" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PanaLaData" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PanaLaData" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_NormaBaza" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NormaBaza" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ServiciiPeChitanta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServiciiPeChitanta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ServiciiPeChitanta" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ServiciiPeChitanta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Clasa" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Clasa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Grupa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Grupa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Grupa" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Grupa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDJurnal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJurnal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDJurnal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJurnal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SalarFunctie" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SalarFunctie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Marca" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Marca" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Marca" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Marca" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NrContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NrContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NrContract" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataContract" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TipContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PerioadaDeterminata" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PerioadaDeterminata" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PerioadaDeterminata" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PerioadaDeterminata" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Observatii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Observatii" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DurataContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DurataContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DurataContract" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DurataContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[AngajatiSalarizare] ([IdPersoana], [DeLaData], [Salar], [IDDepartament], [IdTipGrad], [OreNorma], [FractiuneNorma], [PanaLaData], [NormaBaza], [ServiciiPeChitanta], [CodUnitate], [Clasa], [Grupa], [IDJurnal], [SalarFunctie], [Marca], [NrContract], [DataContract], [TipContract], [PerioadaDeterminata], [Observatii], [DurataContract]) VALUES (@IdPersoana, @DeLaData, @Salar, @IDDepartament, @IdTipGrad, @OreNorma, @FractiuneNorma, @PanaLaData, @NormaBaza, @ServiciiPeChitanta, @CodUnitate, @Clasa, @Grupa, @IDJurnal, @SalarFunctie, @Marca, @NrContract, @DataContract, @TipContract, @PerioadaDeterminata, @Observatii, @DurataContract);
SELECT IDAngajatSalarizare, IdPersoana, DeLaData, Salar, IDDepartament, IdTipGrad, OreNorma, FractiuneNorma, PanaLaData, NormaBaza, ServiciiPeChitanta, CodUnitate, Clasa, Grupa, IDJurnal, SalarFunctie, Marca, NrContract, DataContract, TipContract, PerioadaDeterminata, Observatii, DurataContract FROM AngajatiSalarizare WHERE (IDAngajatSalarizare = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdPersoana" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdPersoana" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DeLaData" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DeLaData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Salar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Salar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDDepartament" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDDepartament" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdTipGrad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipGrad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@OreNorma" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="OreNorma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FractiuneNorma" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="FractiuneNorma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PanaLaData" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PanaLaData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@NormaBaza" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NormaBaza" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ServiciiPeChitanta" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ServiciiPeChitanta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Clasa" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Clasa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Grupa" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Grupa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDJurnal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJurnal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SalarFunctie" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SalarFunctie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Marca" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Marca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NrContract" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataContract" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TipContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PerioadaDeterminata" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PerioadaDeterminata" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Observatii" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DurataContract" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DurataContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDAngajatSalarizare, IdPersoana, DeLaData, Salar, IDDepartament, IdTipGrad, OreNorma, FractiuneNorma, PanaLaData, NormaBaza, ServiciiPeChitanta, CodUnitate, Clasa, Grupa, IDJurnal, SalarFunctie, Marca, NrContract, DataContract, TipContract, PerioadaDeterminata, Observatii, DurataContract FROM dbo.AngajatiSalarizare</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[AngajatiSalarizare] SET [IdPersoana] = @IdPersoana, [DeLaData] = @DeLaData, [Salar] = @Salar, [IDDepartament] = @IDDepartament, [IdTipGrad] = @IdTipGrad, [OreNorma] = @OreNorma, [FractiuneNorma] = @FractiuneNorma, [PanaLaData] = @PanaLaData, [NormaBaza] = @NormaBaza, [ServiciiPeChitanta] = @ServiciiPeChitanta, [CodUnitate] = @CodUnitate, [Clasa] = @Clasa, [Grupa] = @Grupa, [IDJurnal] = @IDJurnal, [SalarFunctie] = @SalarFunctie, [Marca] = @Marca, [NrContract] = @NrContract, [DataContract] = @DataContract, [TipContract] = @TipContract, [PerioadaDeterminata] = @PerioadaDeterminata, [Observatii] = @Observatii, [DurataContract] = @DurataContract WHERE (([IDAngajatSalarizare] = @Original_IDAngajatSalarizare) AND ([IdPersoana] = @Original_IdPersoana) AND ([DeLaData] = @Original_DeLaData) AND ([Salar] = @Original_Salar) AND ([IDDepartament] = @Original_IDDepartament) AND ([IdTipGrad] = @Original_IdTipGrad) AND ([OreNorma] = @Original_OreNorma) AND ([FractiuneNorma] = @Original_FractiuneNorma) AND ((@IsNull_PanaLaData = 1 AND [PanaLaData] IS NULL) OR ([PanaLaData] = @Original_PanaLaData)) AND ([NormaBaza] = @Original_NormaBaza) AND ((@IsNull_ServiciiPeChitanta = 1 AND [ServiciiPeChitanta] IS NULL) OR ([ServiciiPeChitanta] = @Original_ServiciiPeChitanta)) AND ([CodUnitate] = @Original_CodUnitate) AND ([Clasa] = @Original_Clasa) AND ((@IsNull_Grupa = 1 AND [Grupa] IS NULL) OR ([Grupa] = @Original_Grupa)) AND ((@IsNull_IDJurnal = 1 AND [IDJurnal] IS NULL) OR ([IDJurnal] = @Original_IDJurnal)) AND ([SalarFunctie] = @Original_SalarFunctie) AND ((@IsNull_Marca = 1 AND [Marca] IS NULL) OR ([Marca] = @Original_Marca)) AND ((@IsNull_NrContract = 1 AND [NrContract] IS NULL) OR ([NrContract] = @Original_NrContract)) AND ((@IsNull_DataContract = 1 AND [DataContract] IS NULL) OR ([DataContract] = @Original_DataContract)) AND ((@IsNull_TipContract = 1 AND [TipContract] IS NULL) OR ([TipContract] = @Original_TipContract)) AND ((@IsNull_PerioadaDeterminata = 1 AND [PerioadaDeterminata] IS NULL) OR ([PerioadaDeterminata] = @Original_PerioadaDeterminata)) AND ((@IsNull_Observatii = 1 AND [Observatii] IS NULL) OR ([Observatii] = @Original_Observatii)) AND ((@IsNull_DurataContract = 1 AND [DurataContract] IS NULL) OR ([DurataContract] = @Original_DurataContract)));
SELECT IDAngajatSalarizare, IdPersoana, DeLaData, Salar, IDDepartament, IdTipGrad, OreNorma, FractiuneNorma, PanaLaData, NormaBaza, ServiciiPeChitanta, CodUnitate, Clasa, Grupa, IDJurnal, SalarFunctie, Marca, NrContract, DataContract, TipContract, PerioadaDeterminata, Observatii, DurataContract FROM AngajatiSalarizare WHERE (IDAngajatSalarizare = @IDAngajatSalarizare)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdPersoana" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdPersoana" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DeLaData" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DeLaData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Salar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Salar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDDepartament" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDDepartament" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdTipGrad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipGrad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@OreNorma" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="OreNorma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FractiuneNorma" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="FractiuneNorma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PanaLaData" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PanaLaData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@NormaBaza" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NormaBaza" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ServiciiPeChitanta" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ServiciiPeChitanta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Clasa" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Clasa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Grupa" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Grupa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDJurnal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJurnal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SalarFunctie" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SalarFunctie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Marca" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Marca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NrContract" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataContract" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TipContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PerioadaDeterminata" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PerioadaDeterminata" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Observatii" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DurataContract" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DurataContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDAngajatSalarizare" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAngajatSalarizare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdPersoana" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdPersoana" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DeLaData" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DeLaData" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Salar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Salar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDDepartament" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDDepartament" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdTipGrad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipGrad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_OreNorma" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="OreNorma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_FractiuneNorma" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="FractiuneNorma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PanaLaData" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PanaLaData" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PanaLaData" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PanaLaData" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_NormaBaza" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NormaBaza" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ServiciiPeChitanta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServiciiPeChitanta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ServiciiPeChitanta" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ServiciiPeChitanta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Clasa" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Clasa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Grupa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Grupa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Grupa" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Grupa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDJurnal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJurnal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDJurnal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJurnal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SalarFunctie" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SalarFunctie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Marca" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Marca" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Marca" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Marca" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NrContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NrContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NrContract" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataContract" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TipContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PerioadaDeterminata" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PerioadaDeterminata" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PerioadaDeterminata" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PerioadaDeterminata" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Observatii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Observatii" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DurataContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DurataContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DurataContract" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DurataContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDAngajatSalarizare" ColumnName="IDAngajatSalarizare" DataSourceName="ESRP.dbo.AngajatiSalarizare" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDAngajatSalarizare" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDAngajatSalarizare" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDAngajatSalarizare" DataSetColumn="IDAngajatSalarizare" />
              <Mapping SourceColumn="IdPersoana" DataSetColumn="IdPersoana" />
              <Mapping SourceColumn="DeLaData" DataSetColumn="DeLaData" />
              <Mapping SourceColumn="Salar" DataSetColumn="Salar" />
              <Mapping SourceColumn="IDDepartament" DataSetColumn="IDDepartament" />
              <Mapping SourceColumn="IdTipGrad" DataSetColumn="IdTipGrad" />
              <Mapping SourceColumn="OreNorma" DataSetColumn="OreNorma" />
              <Mapping SourceColumn="FractiuneNorma" DataSetColumn="FractiuneNorma" />
              <Mapping SourceColumn="PanaLaData" DataSetColumn="PanaLaData" />
              <Mapping SourceColumn="NormaBaza" DataSetColumn="NormaBaza" />
              <Mapping SourceColumn="ServiciiPeChitanta" DataSetColumn="ServiciiPeChitanta" />
              <Mapping SourceColumn="CodUnitate" DataSetColumn="CodUnitate" />
              <Mapping SourceColumn="Clasa" DataSetColumn="Clasa" />
              <Mapping SourceColumn="Grupa" DataSetColumn="Grupa" />
              <Mapping SourceColumn="IDJurnal" DataSetColumn="IDJurnal" />
              <Mapping SourceColumn="SalarFunctie" DataSetColumn="SalarFunctie" />
              <Mapping SourceColumn="Marca" DataSetColumn="Marca" />
              <Mapping SourceColumn="NrContract" DataSetColumn="NrContract" />
              <Mapping SourceColumn="DataContract" DataSetColumn="DataContract" />
              <Mapping SourceColumn="TipContract" DataSetColumn="TipContract" />
              <Mapping SourceColumn="PerioadaDeterminata" DataSetColumn="PerioadaDeterminata" />
              <Mapping SourceColumn="Observatii" DataSetColumn="Observatii" />
              <Mapping SourceColumn="DurataContract" DataSetColumn="DurataContract" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PersoaneTableAdapter" GeneratorDataComponentClassName="PersoaneTableAdapter" Name="Persoane" UserDataComponentName="PersoaneTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.Persoane" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Persoane] WHERE (([IdPersoana] = @Original_IdPersoana) AND ([NumePrenume] = @Original_NumePrenume) AND ((@IsNull_Nume_Anterior = 1 AND [Nume_Anterior] IS NULL) OR ([Nume_Anterior] = @Original_Nume_Anterior)) AND ([Cnp] = @Original_Cnp) AND ([Sex] = @Original_Sex) AND ([DataNasterii] = @Original_DataNasterii) AND ([IDLocNastere] = @Original_IDLocNastere) AND ([TipAI] = @Original_TipAI) AND ([SeriaAI] = @Original_SeriaAI) AND ([NumarAI] = @Original_NumarAI) AND ([DataElibAI] = @Original_DataElibAI) AND ([EmitentAI] = @Original_EmitentAI) AND ((@IsNull_NumeTata = 1 AND [NumeTata] IS NULL) OR ([NumeTata] = @Original_NumeTata)) AND ((@IsNull_NumeMama = 1 AND [NumeMama] IS NULL) OR ([NumeMama] = @Original_NumeMama)) AND ([StradaAdr] = @Original_StradaAdr) AND ([IDLocalitateAdr] = @Original_IDLocalitateAdr) AND ([NrAdr] = @Original_NrAdr) AND ([BlocAdr] = @Original_BlocAdr) AND ((@IsNull_EtajAdr = 1 AND [EtajAdr] IS NULL) OR ([EtajAdr] = @Original_EtajAdr)) AND ((@IsNull_ScaraAdr = 1 AND [ScaraAdr] IS NULL) OR ([ScaraAdr] = @Original_ScaraAdr)) AND ([ApartamentAdr] = @Original_ApartamentAdr) AND ((@IsNull_GradInvaliditate = 1 AND [GradInvaliditate] IS NULL) OR ([GradInvaliditate] = @Original_GradInvaliditate)) AND ((@IsNull_TelefonFix = 1 AND [TelefonFix] IS NULL) OR ([TelefonFix] = @Original_TelefonFix)) AND ([TelefonMobil] = @Original_TelefonMobil) AND ((@IsNull_Observatii = 1 AND [Observatii] IS NULL) OR ([Observatii] = @Original_Observatii)) AND ([NumarCM] = @Original_NumarCM) AND ([SerieCM] = @Original_SerieCM) AND ([CodUnitate] = @Original_CodUnitate) AND ([NrFileCM] = @Original_NrFileCM) AND ([NrCutieCM] = @Original_NrCutieCM) AND ([Marca] = @Original_Marca) AND ((@IsNull_TelefonInterior = 1 AND [TelefonInterior] IS NULL) OR ([TelefonInterior] = @Original_TelefonInterior)) AND ([IdCasaAsigSanatate] = @Original_IdCasaAsigSanatate) AND ([IdTipStudii] = @Original_IdTipStudii) AND ([DataVechimeMunca] = @Original_DataVechimeMunca) AND ((@IsNull_UserID = 1 AND [UserID] IS NULL) OR ([UserID] = @Original_UserID)) AND ([PozCutieCM] = @Original_PozCutieCM) AND ([PlatesteCAS] = @Original_PlatesteCAS) AND ([PlatesteCASS] = @Original_PlatesteCASS) AND ([PlatesteSomaj] = @Original_PlatesteSomaj) AND ([PlatesteImpozit] = @Original_PlatesteImpozit) AND ([AreDeducere] = @Original_AreDeducere) AND ((@IsNull_DataPlecarii = 1 AND [DataPlecarii] IS NULL) OR ([DataPlecarii] = @Original_DataPlecarii)) AND ((@IsNull_MotivIncetareContract = 1 AND [MotivIncetareContract] IS NULL) OR ([MotivIncetareContract] = @Original_MotivIncetareContract)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdPersoana" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdPersoana" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumePrenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumePrenume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume_Anterior" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume_Anterior" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume_Anterior" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume_Anterior" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cnp" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Sex" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataNasterii" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataNasterii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLocNastere" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocNastere" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_TipAI" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SeriaAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SeriaAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumarAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataElibAI" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataElibAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EmitentAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmitentAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumeTata" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumeTata" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumeTata" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumeTata" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumeMama" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumeMama" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumeMama" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumeMama" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_StradaAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StradaAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLocalitateAdr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitateAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NrAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BlocAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BlocAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EtajAdr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EtajAdr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EtajAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EtajAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ScaraAdr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScaraAdr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ScaraAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ScaraAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ApartamentAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ApartamentAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GradInvaliditate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GradInvaliditate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_GradInvaliditate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GradInvaliditate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TelefonFix" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TelefonFix" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TelefonFix" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonFix" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TelefonMobil" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonMobil" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Observatii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Observatii" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumarCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumarCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SerieCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_NrFileCM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NrFileCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NrCutieCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrCutieCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Marca" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Marca" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TelefonInterior" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TelefonInterior" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TelefonInterior" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonInterior" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IdCasaAsigSanatate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IdCasaAsigSanatate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdTipStudii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipStudii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataVechimeMunca" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataVechimeMunca" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_PozCutieCM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PozCutieCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlatesteCAS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteCAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlatesteCASS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteCASS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlatesteSomaj" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteSomaj" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlatesteImpozit" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteImpozit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AreDeducere" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AreDeducere" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataPlecarii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataPlecarii" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataPlecarii" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataPlecarii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MotivIncetareContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MotivIncetareContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MotivIncetareContract" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MotivIncetareContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Persoane] ([NumePrenume], [Nume_Anterior], [Cnp], [Sex], [DataNasterii], [IDLocNastere], [TipAI], [SeriaAI], [NumarAI], [DataElibAI], [EmitentAI], [NumeTata], [NumeMama], [StradaAdr], [IDLocalitateAdr], [NrAdr], [BlocAdr], [EtajAdr], [ScaraAdr], [ApartamentAdr], [GradInvaliditate], [TelefonFix], [TelefonMobil], [Observatii], [NumarCM], [SerieCM], [CodUnitate], [NrFileCM], [NrCutieCM], [Marca], [TelefonInterior], [IdCasaAsigSanatate], [IdTipStudii], [DataVechimeMunca], [UserID], [PozCutieCM], [PlatesteCAS], [PlatesteCASS], [PlatesteSomaj], [PlatesteImpozit], [AreDeducere], [DataPlecarii], [MotivIncetareContract]) VALUES (@NumePrenume, @Nume_Anterior, @Cnp, @Sex, @DataNasterii, @IDLocNastere, @TipAI, @SeriaAI, @NumarAI, @DataElibAI, @EmitentAI, @NumeTata, @NumeMama, @StradaAdr, @IDLocalitateAdr, @NrAdr, @BlocAdr, @EtajAdr, @ScaraAdr, @ApartamentAdr, @GradInvaliditate, @TelefonFix, @TelefonMobil, @Observatii, @NumarCM, @SerieCM, @CodUnitate, @NrFileCM, @NrCutieCM, @Marca, @TelefonInterior, @IdCasaAsigSanatate, @IdTipStudii, @DataVechimeMunca, @UserID, @PozCutieCM, @PlatesteCAS, @PlatesteCASS, @PlatesteSomaj, @PlatesteImpozit, @AreDeducere, @DataPlecarii, @MotivIncetareContract);
SELECT IdPersoana, NumePrenume, Nume_Anterior, Cnp, Sex, DataNasterii, IDLocNastere, TipAI, SeriaAI, NumarAI, DataElibAI, EmitentAI, NumeTata, NumeMama, StradaAdr, IDLocalitateAdr, NrAdr, BlocAdr, EtajAdr, ScaraAdr, ApartamentAdr, GradInvaliditate, TelefonFix, TelefonMobil, Observatii, NumarCM, SerieCM, CodUnitate, NrFileCM, NrCutieCM, Marca, TelefonInterior, IdCasaAsigSanatate, IdTipStudii, DataVechimeMunca, UserID, PozCutieCM, PlatesteCAS, PlatesteCASS, PlatesteSomaj, PlatesteImpozit, AreDeducere, DataPlecarii, MotivIncetareContract FROM Persoane WHERE (IdPersoana = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumePrenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumePrenume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume_Anterior" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume_Anterior" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cnp" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Sex" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataNasterii" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataNasterii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDLocNastere" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocNastere" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@TipAI" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SeriaAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SeriaAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumarAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataElibAI" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataElibAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmitentAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmitentAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumeTata" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumeTata" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumeMama" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumeMama" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StradaAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StradaAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDLocalitateAdr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitateAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NrAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BlocAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BlocAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EtajAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EtajAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ScaraAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ScaraAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ApartamentAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ApartamentAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@GradInvaliditate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GradInvaliditate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TelefonFix" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonFix" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TelefonMobil" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonMobil" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Observatii" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumarCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumarCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SerieCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@NrFileCM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NrFileCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NrCutieCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrCutieCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Marca" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Marca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TelefonInterior" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonInterior" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IdCasaAsigSanatate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IdCasaAsigSanatate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdTipStudii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipStudii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataVechimeMunca" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataVechimeMunca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@PozCutieCM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PozCutieCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlatesteCAS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteCAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlatesteCASS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteCASS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlatesteSomaj" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteSomaj" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlatesteImpozit" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteImpozit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AreDeducere" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AreDeducere" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataPlecarii" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataPlecarii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MotivIncetareContract" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MotivIncetareContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT IdPersoana, NumePrenume, Nume_Anterior, Cnp, Sex, DataNasterii, IDLocNastere, TipAI, SeriaAI, NumarAI, DataElibAI, EmitentAI, NumeTata, NumeMama, StradaAdr, IDLocalitateAdr, NrAdr, BlocAdr, EtajAdr, ScaraAdr, ApartamentAdr, GradInvaliditate, TelefonFix, TelefonMobil, Observatii, NumarCM, SerieCM, CodUnitate, NrFileCM, NrCutieCM, Marca, TelefonInterior, IdCasaAsigSanatate, IdTipStudii, DataVechimeMunca, UserID, PozCutieCM, PlatesteCAS, PlatesteCASS, PlatesteSomaj, PlatesteImpozit, AreDeducere, DataPlecarii, MotivIncetareContract FROM dbo.Persoane WHERE CodUnitate=@CodUnitate</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CodUnitate" ColumnName="CodUnitate" DataSourceName="ESRP.dbo.Persoane" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Persoane] SET [NumePrenume] = @NumePrenume, [Nume_Anterior] = @Nume_Anterior, [Cnp] = @Cnp, [Sex] = @Sex, [DataNasterii] = @DataNasterii, [IDLocNastere] = @IDLocNastere, [TipAI] = @TipAI, [SeriaAI] = @SeriaAI, [NumarAI] = @NumarAI, [DataElibAI] = @DataElibAI, [EmitentAI] = @EmitentAI, [NumeTata] = @NumeTata, [NumeMama] = @NumeMama, [StradaAdr] = @StradaAdr, [IDLocalitateAdr] = @IDLocalitateAdr, [NrAdr] = @NrAdr, [BlocAdr] = @BlocAdr, [EtajAdr] = @EtajAdr, [ScaraAdr] = @ScaraAdr, [ApartamentAdr] = @ApartamentAdr, [GradInvaliditate] = @GradInvaliditate, [TelefonFix] = @TelefonFix, [TelefonMobil] = @TelefonMobil, [Observatii] = @Observatii, [NumarCM] = @NumarCM, [SerieCM] = @SerieCM, [CodUnitate] = @CodUnitate, [NrFileCM] = @NrFileCM, [NrCutieCM] = @NrCutieCM, [Marca] = @Marca, [TelefonInterior] = @TelefonInterior, [IdCasaAsigSanatate] = @IdCasaAsigSanatate, [IdTipStudii] = @IdTipStudii, [DataVechimeMunca] = @DataVechimeMunca, [UserID] = @UserID, [PozCutieCM] = @PozCutieCM, [PlatesteCAS] = @PlatesteCAS, [PlatesteCASS] = @PlatesteCASS, [PlatesteSomaj] = @PlatesteSomaj, [PlatesteImpozit] = @PlatesteImpozit, [AreDeducere] = @AreDeducere, [DataPlecarii] = @DataPlecarii, [MotivIncetareContract] = @MotivIncetareContract WHERE (([IdPersoana] = @Original_IdPersoana) AND ([NumePrenume] = @Original_NumePrenume) AND ((@IsNull_Nume_Anterior = 1 AND [Nume_Anterior] IS NULL) OR ([Nume_Anterior] = @Original_Nume_Anterior)) AND ([Cnp] = @Original_Cnp) AND ([Sex] = @Original_Sex) AND ([DataNasterii] = @Original_DataNasterii) AND ([IDLocNastere] = @Original_IDLocNastere) AND ([TipAI] = @Original_TipAI) AND ([SeriaAI] = @Original_SeriaAI) AND ([NumarAI] = @Original_NumarAI) AND ([DataElibAI] = @Original_DataElibAI) AND ([EmitentAI] = @Original_EmitentAI) AND ((@IsNull_NumeTata = 1 AND [NumeTata] IS NULL) OR ([NumeTata] = @Original_NumeTata)) AND ((@IsNull_NumeMama = 1 AND [NumeMama] IS NULL) OR ([NumeMama] = @Original_NumeMama)) AND ([StradaAdr] = @Original_StradaAdr) AND ([IDLocalitateAdr] = @Original_IDLocalitateAdr) AND ([NrAdr] = @Original_NrAdr) AND ([BlocAdr] = @Original_BlocAdr) AND ((@IsNull_EtajAdr = 1 AND [EtajAdr] IS NULL) OR ([EtajAdr] = @Original_EtajAdr)) AND ((@IsNull_ScaraAdr = 1 AND [ScaraAdr] IS NULL) OR ([ScaraAdr] = @Original_ScaraAdr)) AND ([ApartamentAdr] = @Original_ApartamentAdr) AND ((@IsNull_GradInvaliditate = 1 AND [GradInvaliditate] IS NULL) OR ([GradInvaliditate] = @Original_GradInvaliditate)) AND ((@IsNull_TelefonFix = 1 AND [TelefonFix] IS NULL) OR ([TelefonFix] = @Original_TelefonFix)) AND ([TelefonMobil] = @Original_TelefonMobil) AND ((@IsNull_Observatii = 1 AND [Observatii] IS NULL) OR ([Observatii] = @Original_Observatii)) AND ([NumarCM] = @Original_NumarCM) AND ([SerieCM] = @Original_SerieCM) AND ([CodUnitate] = @Original_CodUnitate) AND ([NrFileCM] = @Original_NrFileCM) AND ([NrCutieCM] = @Original_NrCutieCM) AND ([Marca] = @Original_Marca) AND ((@IsNull_TelefonInterior = 1 AND [TelefonInterior] IS NULL) OR ([TelefonInterior] = @Original_TelefonInterior)) AND ([IdCasaAsigSanatate] = @Original_IdCasaAsigSanatate) AND ([IdTipStudii] = @Original_IdTipStudii) AND ([DataVechimeMunca] = @Original_DataVechimeMunca) AND ((@IsNull_UserID = 1 AND [UserID] IS NULL) OR ([UserID] = @Original_UserID)) AND ([PozCutieCM] = @Original_PozCutieCM) AND ([PlatesteCAS] = @Original_PlatesteCAS) AND ([PlatesteCASS] = @Original_PlatesteCASS) AND ([PlatesteSomaj] = @Original_PlatesteSomaj) AND ([PlatesteImpozit] = @Original_PlatesteImpozit) AND ([AreDeducere] = @Original_AreDeducere) AND ((@IsNull_DataPlecarii = 1 AND [DataPlecarii] IS NULL) OR ([DataPlecarii] = @Original_DataPlecarii)) AND ((@IsNull_MotivIncetareContract = 1 AND [MotivIncetareContract] IS NULL) OR ([MotivIncetareContract] = @Original_MotivIncetareContract)));
SELECT IdPersoana, NumePrenume, Nume_Anterior, Cnp, Sex, DataNasterii, IDLocNastere, TipAI, SeriaAI, NumarAI, DataElibAI, EmitentAI, NumeTata, NumeMama, StradaAdr, IDLocalitateAdr, NrAdr, BlocAdr, EtajAdr, ScaraAdr, ApartamentAdr, GradInvaliditate, TelefonFix, TelefonMobil, Observatii, NumarCM, SerieCM, CodUnitate, NrFileCM, NrCutieCM, Marca, TelefonInterior, IdCasaAsigSanatate, IdTipStudii, DataVechimeMunca, UserID, PozCutieCM, PlatesteCAS, PlatesteCASS, PlatesteSomaj, PlatesteImpozit, AreDeducere, DataPlecarii, MotivIncetareContract FROM Persoane WHERE (IdPersoana = @IdPersoana)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumePrenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumePrenume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume_Anterior" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume_Anterior" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cnp" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Sex" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataNasterii" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataNasterii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDLocNastere" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocNastere" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@TipAI" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SeriaAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SeriaAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumarAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataElibAI" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataElibAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmitentAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmitentAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumeTata" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumeTata" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumeMama" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumeMama" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StradaAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StradaAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDLocalitateAdr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitateAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NrAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BlocAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BlocAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EtajAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EtajAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ScaraAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ScaraAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ApartamentAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ApartamentAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@GradInvaliditate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GradInvaliditate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TelefonFix" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonFix" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TelefonMobil" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonMobil" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Observatii" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumarCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumarCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SerieCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@NrFileCM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NrFileCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NrCutieCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrCutieCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Marca" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Marca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TelefonInterior" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonInterior" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IdCasaAsigSanatate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IdCasaAsigSanatate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdTipStudii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipStudii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataVechimeMunca" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataVechimeMunca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@PozCutieCM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PozCutieCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlatesteCAS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteCAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlatesteCASS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteCASS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlatesteSomaj" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteSomaj" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlatesteImpozit" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteImpozit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AreDeducere" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AreDeducere" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataPlecarii" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataPlecarii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MotivIncetareContract" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MotivIncetareContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdPersoana" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdPersoana" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumePrenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumePrenume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume_Anterior" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume_Anterior" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume_Anterior" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume_Anterior" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cnp" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Sex" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataNasterii" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataNasterii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLocNastere" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocNastere" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_TipAI" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SeriaAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SeriaAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumarAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataElibAI" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataElibAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EmitentAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmitentAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumeTata" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumeTata" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumeTata" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumeTata" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumeMama" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumeMama" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumeMama" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumeMama" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_StradaAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StradaAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLocalitateAdr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitateAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NrAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BlocAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BlocAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EtajAdr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EtajAdr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EtajAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EtajAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ScaraAdr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScaraAdr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ScaraAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ScaraAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ApartamentAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ApartamentAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GradInvaliditate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GradInvaliditate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_GradInvaliditate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GradInvaliditate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TelefonFix" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TelefonFix" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TelefonFix" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonFix" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TelefonMobil" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonMobil" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Observatii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Observatii" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumarCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumarCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SerieCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_NrFileCM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NrFileCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NrCutieCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrCutieCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Marca" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Marca" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TelefonInterior" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TelefonInterior" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TelefonInterior" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonInterior" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IdCasaAsigSanatate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IdCasaAsigSanatate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdTipStudii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipStudii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataVechimeMunca" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataVechimeMunca" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_PozCutieCM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PozCutieCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlatesteCAS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteCAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlatesteCASS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteCASS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlatesteSomaj" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteSomaj" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlatesteImpozit" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteImpozit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AreDeducere" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AreDeducere" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataPlecarii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataPlecarii" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataPlecarii" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataPlecarii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MotivIncetareContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MotivIncetareContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MotivIncetareContract" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MotivIncetareContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdPersoana" ColumnName="IdPersoana" DataSourceName="ESRP.dbo.Persoane" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdPersoana" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdPersoana" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdPersoana" DataSetColumn="IdPersoana" />
              <Mapping SourceColumn="NumePrenume" DataSetColumn="NumePrenume" />
              <Mapping SourceColumn="Nume_Anterior" DataSetColumn="Nume_Anterior" />
              <Mapping SourceColumn="Cnp" DataSetColumn="Cnp" />
              <Mapping SourceColumn="Sex" DataSetColumn="Sex" />
              <Mapping SourceColumn="DataNasterii" DataSetColumn="DataNasterii" />
              <Mapping SourceColumn="IDLocNastere" DataSetColumn="IDLocNastere" />
              <Mapping SourceColumn="TipAI" DataSetColumn="TipAI" />
              <Mapping SourceColumn="SeriaAI" DataSetColumn="SeriaAI" />
              <Mapping SourceColumn="NumarAI" DataSetColumn="NumarAI" />
              <Mapping SourceColumn="DataElibAI" DataSetColumn="DataElibAI" />
              <Mapping SourceColumn="EmitentAI" DataSetColumn="EmitentAI" />
              <Mapping SourceColumn="NumeTata" DataSetColumn="NumeTata" />
              <Mapping SourceColumn="NumeMama" DataSetColumn="NumeMama" />
              <Mapping SourceColumn="StradaAdr" DataSetColumn="StradaAdr" />
              <Mapping SourceColumn="IDLocalitateAdr" DataSetColumn="IDLocalitateAdr" />
              <Mapping SourceColumn="NrAdr" DataSetColumn="NrAdr" />
              <Mapping SourceColumn="BlocAdr" DataSetColumn="BlocAdr" />
              <Mapping SourceColumn="EtajAdr" DataSetColumn="EtajAdr" />
              <Mapping SourceColumn="ScaraAdr" DataSetColumn="ScaraAdr" />
              <Mapping SourceColumn="ApartamentAdr" DataSetColumn="ApartamentAdr" />
              <Mapping SourceColumn="GradInvaliditate" DataSetColumn="GradInvaliditate" />
              <Mapping SourceColumn="TelefonFix" DataSetColumn="TelefonFix" />
              <Mapping SourceColumn="TelefonMobil" DataSetColumn="TelefonMobil" />
              <Mapping SourceColumn="Observatii" DataSetColumn="Observatii" />
              <Mapping SourceColumn="NumarCM" DataSetColumn="NumarCM" />
              <Mapping SourceColumn="SerieCM" DataSetColumn="SerieCM" />
              <Mapping SourceColumn="CodUnitate" DataSetColumn="CodUnitate" />
              <Mapping SourceColumn="NrFileCM" DataSetColumn="NrFileCM" />
              <Mapping SourceColumn="NrCutieCM" DataSetColumn="NrCutieCM" />
              <Mapping SourceColumn="Marca" DataSetColumn="Marca" />
              <Mapping SourceColumn="TelefonInterior" DataSetColumn="TelefonInterior" />
              <Mapping SourceColumn="IdCasaAsigSanatate" DataSetColumn="IdCasaAsigSanatate" />
              <Mapping SourceColumn="IdTipStudii" DataSetColumn="IdTipStudii" />
              <Mapping SourceColumn="DataVechimeMunca" DataSetColumn="DataVechimeMunca" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="PozCutieCM" DataSetColumn="PozCutieCM" />
              <Mapping SourceColumn="PlatesteCAS" DataSetColumn="PlatesteCAS" />
              <Mapping SourceColumn="PlatesteCASS" DataSetColumn="PlatesteCASS" />
              <Mapping SourceColumn="PlatesteSomaj" DataSetColumn="PlatesteSomaj" />
              <Mapping SourceColumn="PlatesteImpozit" DataSetColumn="PlatesteImpozit" />
              <Mapping SourceColumn="AreDeducere" DataSetColumn="AreDeducere" />
              <Mapping SourceColumn="DataPlecarii" DataSetColumn="DataPlecarii" />
              <Mapping SourceColumn="MotivIncetareContract" DataSetColumn="MotivIncetareContract" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ResUmaSetupTableAdapter" GeneratorDataComponentClassName="ResUmaSetupTableAdapter" Name="ResUmaSetup" UserDataComponentName="ResUmaSetupTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.ResUmaSetup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ResUmaSetup] WHERE (([PrimaryKey] = @Original_PrimaryKey) AND ([CodUnitate] = @Original_CodUnitate) AND ([AnulCurent] = @Original_AnulCurent) AND ([LunaCurenta] = @Original_LunaCurenta) AND ([PropagaModificari] = @Original_PropagaModificari) AND ([Contracte] = @Original_Contracte) AND ([ProcentCASAngajator] = @Original_ProcentCASAngajator) AND ([SalarMinim] = @Original_SalarMinim) AND ([SalarMediuBrut] = @Original_SalarMediuBrut) AND ([NrSalariiMaxCAS] = @Original_NrSalariiMaxCAS) AND ([ProcentCASAngajat] = @Original_ProcentCASAngajat) AND ([PlafonareCAS] = @Original_PlafonareCAS) AND ([ProcentSomajAngajat] = @Original_ProcentSomajAngajat) AND ([ProcentSomajAngajator] = @Original_ProcentSomajAngajator) AND ([ProcentASSAngajat] = @Original_ProcentASSAngajat) AND ([ProcentASSAngajator] = @Original_ProcentASSAngajator) AND ((@IsNull_ScanRes = 1 AND [ScanRes] IS NULL) OR ([ScanRes] = @Original_ScanRes)) AND ((@IsNull_OrizExtent = 1 AND [OrizExtent] IS NULL) OR ([OrizExtent] = @Original_OrizExtent)) AND ((@IsNull_VertExtent = 1 AND [VertExtent] IS NULL) OR ([VertExtent] = @Original_VertExtent)) AND ((@IsNull_ColorFormat = 1 AND [ColorFormat] IS NULL) OR ([ColorFormat] = @Original_ColorFormat)) AND ((@IsNull_ScanDebug = 1 AND [ScanDebug] IS NULL) OR ([ScanDebug] = @Original_ScanDebug)) AND ([VersiuneCOR] = @Original_VersiuneCOR))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_PrimaryKey" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PrimaryKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_AnulCurent" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="AnulCurent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_LunaCurenta" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="LunaCurenta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PropagaModificari" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PropagaModificari" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Contracte" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Contracte" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ProcentCASAngajator" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentCASAngajator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SalarMinim" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SalarMinim" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SalarMediuBrut" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SalarMediuBrut" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_NrSalariiMaxCAS" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NrSalariiMaxCAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ProcentCASAngajat" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentCASAngajat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlafonareCAS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlafonareCAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ProcentSomajAngajat" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentSomajAngajat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ProcentSomajAngajator" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentSomajAngajator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ProcentASSAngajat" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentASSAngajat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ProcentASSAngajator" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentASSAngajator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ScanRes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScanRes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ScanRes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScanRes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OrizExtent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrizExtent" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrizExtent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrizExtent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VertExtent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VertExtent" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VertExtent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VertExtent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ColorFormat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ColorFormat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ColorFormat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ColorFormat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ScanDebug" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScanDebug" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ScanDebug" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ScanDebug" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_VersiuneCOR" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="VersiuneCOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ResUmaSetup] ([PrimaryKey], [CodUnitate], [AnulCurent], [LunaCurenta], [PropagaModificari], [Contracte], [ProcentCASAngajator], [SalarMinim], [SalarMediuBrut], [NrSalariiMaxCAS], [ProcentCASAngajat], [PlafonareCAS], [ProcentSomajAngajat], [ProcentSomajAngajator], [ProcentASSAngajat], [ProcentASSAngajator], [ScanRes], [OrizExtent], [VertExtent], [ColorFormat], [ScanDebug], [VersiuneCOR]) VALUES (@PrimaryKey, @CodUnitate, @AnulCurent, @LunaCurenta, @PropagaModificari, @Contracte, @ProcentCASAngajator, @SalarMinim, @SalarMediuBrut, @NrSalariiMaxCAS, @ProcentCASAngajat, @PlafonareCAS, @ProcentSomajAngajat, @ProcentSomajAngajator, @ProcentASSAngajat, @ProcentASSAngajator, @ScanRes, @OrizExtent, @VertExtent, @ColorFormat, @ScanDebug, @VersiuneCOR);
SELECT PrimaryKey, CodUnitate, AnulCurent, LunaCurenta, PropagaModificari, Contracte, ProcentCASAngajator, SalarMinim, SalarMediuBrut, NrSalariiMaxCAS, ProcentCASAngajat, PlafonareCAS, ProcentSomajAngajat, ProcentSomajAngajator, ProcentASSAngajat, ProcentASSAngajator, ScanRes, OrizExtent, VertExtent, ColorFormat, ScanDebug, VersiuneCOR FROM ResUmaSetup WHERE (CodUnitate = @CodUnitate) AND (PrimaryKey = @PrimaryKey)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@PrimaryKey" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PrimaryKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@AnulCurent" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="AnulCurent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@LunaCurenta" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="LunaCurenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PropagaModificari" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PropagaModificari" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Contracte" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Contracte" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ProcentCASAngajator" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentCASAngajator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SalarMinim" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SalarMinim" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SalarMediuBrut" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SalarMediuBrut" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@NrSalariiMaxCAS" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NrSalariiMaxCAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ProcentCASAngajat" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentCASAngajat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlafonareCAS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlafonareCAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ProcentSomajAngajat" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentSomajAngajat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ProcentSomajAngajator" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentSomajAngajator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ProcentASSAngajat" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentASSAngajat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ProcentASSAngajator" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentASSAngajator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ScanRes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScanRes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrizExtent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrizExtent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VertExtent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VertExtent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ColorFormat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ColorFormat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ScanDebug" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ScanDebug" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@VersiuneCOR" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="VersiuneCOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT PrimaryKey, CodUnitate, AnulCurent, LunaCurenta, PropagaModificari, Contracte, ProcentCASAngajator, SalarMinim, SalarMediuBrut, NrSalariiMaxCAS, ProcentCASAngajat, PlafonareCAS, ProcentSomajAngajat, ProcentSomajAngajator, ProcentASSAngajat, ProcentASSAngajator, ScanRes, OrizExtent, VertExtent, ColorFormat, ScanDebug, VersiuneCOR FROM dbo.ResUmaSetup
WHERE CodUnitate=@CodUnitate</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CodUnitate" ColumnName="CodUnitate" DataSourceName="ESRP.dbo.ResUmaSetup" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ResUmaSetup] SET [PrimaryKey] = @PrimaryKey, [CodUnitate] = @CodUnitate, [AnulCurent] = @AnulCurent, [LunaCurenta] = @LunaCurenta, [PropagaModificari] = @PropagaModificari, [Contracte] = @Contracte, [ProcentCASAngajator] = @ProcentCASAngajator, [SalarMinim] = @SalarMinim, [SalarMediuBrut] = @SalarMediuBrut, [NrSalariiMaxCAS] = @NrSalariiMaxCAS, [ProcentCASAngajat] = @ProcentCASAngajat, [PlafonareCAS] = @PlafonareCAS, [ProcentSomajAngajat] = @ProcentSomajAngajat, [ProcentSomajAngajator] = @ProcentSomajAngajator, [ProcentASSAngajat] = @ProcentASSAngajat, [ProcentASSAngajator] = @ProcentASSAngajator, [ScanRes] = @ScanRes, [OrizExtent] = @OrizExtent, [VertExtent] = @VertExtent, [ColorFormat] = @ColorFormat, [ScanDebug] = @ScanDebug, [VersiuneCOR] = @VersiuneCOR WHERE (([PrimaryKey] = @Original_PrimaryKey) AND ([CodUnitate] = @Original_CodUnitate) AND ([AnulCurent] = @Original_AnulCurent) AND ([LunaCurenta] = @Original_LunaCurenta) AND ([PropagaModificari] = @Original_PropagaModificari) AND ([Contracte] = @Original_Contracte) AND ([ProcentCASAngajator] = @Original_ProcentCASAngajator) AND ([SalarMinim] = @Original_SalarMinim) AND ([SalarMediuBrut] = @Original_SalarMediuBrut) AND ([NrSalariiMaxCAS] = @Original_NrSalariiMaxCAS) AND ([ProcentCASAngajat] = @Original_ProcentCASAngajat) AND ([PlafonareCAS] = @Original_PlafonareCAS) AND ([ProcentSomajAngajat] = @Original_ProcentSomajAngajat) AND ([ProcentSomajAngajator] = @Original_ProcentSomajAngajator) AND ([ProcentASSAngajat] = @Original_ProcentASSAngajat) AND ([ProcentASSAngajator] = @Original_ProcentASSAngajator) AND ((@IsNull_ScanRes = 1 AND [ScanRes] IS NULL) OR ([ScanRes] = @Original_ScanRes)) AND ((@IsNull_OrizExtent = 1 AND [OrizExtent] IS NULL) OR ([OrizExtent] = @Original_OrizExtent)) AND ((@IsNull_VertExtent = 1 AND [VertExtent] IS NULL) OR ([VertExtent] = @Original_VertExtent)) AND ((@IsNull_ColorFormat = 1 AND [ColorFormat] IS NULL) OR ([ColorFormat] = @Original_ColorFormat)) AND ((@IsNull_ScanDebug = 1 AND [ScanDebug] IS NULL) OR ([ScanDebug] = @Original_ScanDebug)) AND ([VersiuneCOR] = @Original_VersiuneCOR));
SELECT PrimaryKey, CodUnitate, AnulCurent, LunaCurenta, PropagaModificari, Contracte, ProcentCASAngajator, SalarMinim, SalarMediuBrut, NrSalariiMaxCAS, ProcentCASAngajat, PlafonareCAS, ProcentSomajAngajat, ProcentSomajAngajator, ProcentASSAngajat, ProcentASSAngajator, ScanRes, OrizExtent, VertExtent, ColorFormat, ScanDebug, VersiuneCOR FROM ResUmaSetup WHERE (CodUnitate = @CodUnitate) AND (PrimaryKey = @PrimaryKey)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@PrimaryKey" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PrimaryKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@AnulCurent" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="AnulCurent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@LunaCurenta" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="LunaCurenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PropagaModificari" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PropagaModificari" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Contracte" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Contracte" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ProcentCASAngajator" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentCASAngajator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SalarMinim" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SalarMinim" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SalarMediuBrut" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SalarMediuBrut" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@NrSalariiMaxCAS" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NrSalariiMaxCAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ProcentCASAngajat" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentCASAngajat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlafonareCAS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlafonareCAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ProcentSomajAngajat" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentSomajAngajat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ProcentSomajAngajator" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentSomajAngajator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ProcentASSAngajat" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentASSAngajat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ProcentASSAngajator" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentASSAngajator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ScanRes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScanRes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrizExtent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrizExtent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VertExtent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VertExtent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ColorFormat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ColorFormat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ScanDebug" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ScanDebug" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@VersiuneCOR" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="VersiuneCOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_PrimaryKey" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PrimaryKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_AnulCurent" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="AnulCurent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_LunaCurenta" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="LunaCurenta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PropagaModificari" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PropagaModificari" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Contracte" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Contracte" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ProcentCASAngajator" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentCASAngajator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SalarMinim" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SalarMinim" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SalarMediuBrut" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SalarMediuBrut" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_NrSalariiMaxCAS" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NrSalariiMaxCAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ProcentCASAngajat" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentCASAngajat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlafonareCAS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlafonareCAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ProcentSomajAngajat" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentSomajAngajat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ProcentSomajAngajator" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentSomajAngajator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ProcentASSAngajat" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentASSAngajat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ProcentASSAngajator" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ProcentASSAngajator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ScanRes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScanRes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ScanRes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScanRes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OrizExtent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrizExtent" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrizExtent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrizExtent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VertExtent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VertExtent" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VertExtent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VertExtent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ColorFormat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ColorFormat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ColorFormat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ColorFormat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ScanDebug" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScanDebug" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ScanDebug" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ScanDebug" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_VersiuneCOR" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="VersiuneCOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PrimaryKey" DataSetColumn="PrimaryKey" />
              <Mapping SourceColumn="CodUnitate" DataSetColumn="CodUnitate" />
              <Mapping SourceColumn="AnulCurent" DataSetColumn="AnulCurent" />
              <Mapping SourceColumn="LunaCurenta" DataSetColumn="LunaCurenta" />
              <Mapping SourceColumn="PropagaModificari" DataSetColumn="PropagaModificari" />
              <Mapping SourceColumn="Contracte" DataSetColumn="Contracte" />
              <Mapping SourceColumn="ProcentCASAngajator" DataSetColumn="ProcentCASAngajator" />
              <Mapping SourceColumn="SalarMinim" DataSetColumn="SalarMinim" />
              <Mapping SourceColumn="SalarMediuBrut" DataSetColumn="SalarMediuBrut" />
              <Mapping SourceColumn="NrSalariiMaxCAS" DataSetColumn="NrSalariiMaxCAS" />
              <Mapping SourceColumn="ProcentCASAngajat" DataSetColumn="ProcentCASAngajat" />
              <Mapping SourceColumn="PlafonareCAS" DataSetColumn="PlafonareCAS" />
              <Mapping SourceColumn="ProcentSomajAngajat" DataSetColumn="ProcentSomajAngajat" />
              <Mapping SourceColumn="ProcentSomajAngajator" DataSetColumn="ProcentSomajAngajator" />
              <Mapping SourceColumn="ProcentASSAngajat" DataSetColumn="ProcentASSAngajat" />
              <Mapping SourceColumn="ProcentASSAngajator" DataSetColumn="ProcentASSAngajator" />
              <Mapping SourceColumn="ScanRes" DataSetColumn="ScanRes" />
              <Mapping SourceColumn="OrizExtent" DataSetColumn="OrizExtent" />
              <Mapping SourceColumn="VertExtent" DataSetColumn="VertExtent" />
              <Mapping SourceColumn="ColorFormat" DataSetColumn="ColorFormat" />
              <Mapping SourceColumn="ScanDebug" DataSetColumn="ScanDebug" />
              <Mapping SourceColumn="VersiuneCOR" DataSetColumn="VersiuneCOR" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AngajatiGarziTableAdapter" GeneratorDataComponentClassName="AngajatiGarziTableAdapter" Name="AngajatiGarzi" UserDataComponentName="AngajatiGarziTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.AngajatiGarzi" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[AngajatiGarzi] WHERE (([IDGarda] = @Original_IDGarda) AND ([CodUnitate] = @Original_CodUnitate) AND ([Luna] = @Original_Luna) AND ([Anul] = @Original_Anul) AND ([IDPersoana] = @Original_IDPersoana) AND ([IDAngajatSalarizare] = @Original_IDAngajatSalarizare) AND ([StartGarda] = @Original_StartGarda) AND ([EndGarda] = @Original_EndGarda) AND ((@IsNull_IDAngajatInlocuit = 1 AND [IDAngajatInlocuit] IS NULL) OR ([IDAngajatInlocuit] = @Original_IDAngajatInlocuit)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDGarda" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDGarda" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Luna" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Luna" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Anul" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Anul" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDPersoana" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPersoana" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDAngajatSalarizare" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAngajatSalarizare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartGarda" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartGarda" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndGarda" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndGarda" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDAngajatInlocuit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAngajatInlocuit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDAngajatInlocuit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAngajatInlocuit" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[AngajatiGarzi] ([CodUnitate], [Luna], [Anul], [IDPersoana], [IDAngajatSalarizare], [StartGarda], [EndGarda], [IDAngajatInlocuit]) VALUES (@CodUnitate, @Luna, @Anul, @IDPersoana, @IDAngajatSalarizare, @StartGarda, @EndGarda, @IDAngajatInlocuit);
SELECT IDGarda, CodUnitate, Luna, Anul, IDPersoana, IDAngajatSalarizare, StartGarda, EndGarda, IDAngajatInlocuit FROM AngajatiGarzi WHERE (IDGarda = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Luna" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Luna" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Anul" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Anul" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDPersoana" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPersoana" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDAngajatSalarizare" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAngajatSalarizare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartGarda" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartGarda" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndGarda" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndGarda" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDAngajatInlocuit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAngajatInlocuit" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT IDGarda, CodUnitate, Luna, Anul, IDPersoana, IDAngajatSalarizare, StartGarda, EndGarda, IDAngajatInlocuit FROM dbo.AngajatiGarzi WHERE 
CodUnitate=@CodUnitate</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CodUnitate" ColumnName="CodUnitate" DataSourceName="ESRP.dbo.AngajatiGarzi" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[AngajatiGarzi] SET [CodUnitate] = @CodUnitate, [Luna] = @Luna, [Anul] = @Anul, [IDPersoana] = @IDPersoana, [IDAngajatSalarizare] = @IDAngajatSalarizare, [StartGarda] = @StartGarda, [EndGarda] = @EndGarda, [IDAngajatInlocuit] = @IDAngajatInlocuit WHERE (([IDGarda] = @Original_IDGarda) AND ([CodUnitate] = @Original_CodUnitate) AND ([Luna] = @Original_Luna) AND ([Anul] = @Original_Anul) AND ([IDPersoana] = @Original_IDPersoana) AND ([IDAngajatSalarizare] = @Original_IDAngajatSalarizare) AND ([StartGarda] = @Original_StartGarda) AND ([EndGarda] = @Original_EndGarda) AND ((@IsNull_IDAngajatInlocuit = 1 AND [IDAngajatInlocuit] IS NULL) OR ([IDAngajatInlocuit] = @Original_IDAngajatInlocuit)));
SELECT IDGarda, CodUnitate, Luna, Anul, IDPersoana, IDAngajatSalarizare, StartGarda, EndGarda, IDAngajatInlocuit FROM AngajatiGarzi WHERE (IDGarda = @IDGarda)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Luna" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Luna" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Anul" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Anul" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDPersoana" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPersoana" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDAngajatSalarizare" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAngajatSalarizare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartGarda" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartGarda" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndGarda" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndGarda" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDAngajatInlocuit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAngajatInlocuit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDGarda" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDGarda" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Luna" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Luna" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Anul" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Anul" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDPersoana" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPersoana" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDAngajatSalarizare" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAngajatSalarizare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartGarda" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartGarda" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndGarda" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndGarda" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDAngajatInlocuit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAngajatInlocuit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDAngajatInlocuit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAngajatInlocuit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDGarda" ColumnName="IDGarda" DataSourceName="ESRP.dbo.AngajatiGarzi" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDGarda" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDGarda" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDGarda" DataSetColumn="IDGarda" />
              <Mapping SourceColumn="CodUnitate" DataSetColumn="CodUnitate" />
              <Mapping SourceColumn="Luna" DataSetColumn="Luna" />
              <Mapping SourceColumn="Anul" DataSetColumn="Anul" />
              <Mapping SourceColumn="IDPersoana" DataSetColumn="IDPersoana" />
              <Mapping SourceColumn="IDAngajatSalarizare" DataSetColumn="IDAngajatSalarizare" />
              <Mapping SourceColumn="StartGarda" DataSetColumn="StartGarda" />
              <Mapping SourceColumn="EndGarda" DataSetColumn="EndGarda" />
              <Mapping SourceColumn="IDAngajatInlocuit" DataSetColumn="IDAngajatInlocuit" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="GarziESRPDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="GarziESRPDataSet" msprop:Generator_UserDSName="GarziESRPDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="AngajatiSalarizare" msprop:Generator_TableClassName="AngajatiSalarizareDataTable" msprop:Generator_TableVarName="tableAngajatiSalarizare" msprop:Generator_RowChangedName="AngajatiSalarizareRowChanged" msprop:Generator_TablePropName="AngajatiSalarizare" msprop:Generator_RowDeletingName="AngajatiSalarizareRowDeleting" msprop:Generator_RowChangingName="AngajatiSalarizareRowChanging" msprop:Generator_RowEvHandlerName="AngajatiSalarizareRowChangeEventHandler" msprop:Generator_RowDeletedName="AngajatiSalarizareRowDeleted" msprop:Generator_RowClassName="AngajatiSalarizareRow" msprop:Generator_UserTableName="AngajatiSalarizare" msprop:Generator_RowEvArgName="AngajatiSalarizareRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDAngajatSalarizare" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDAngajatSalarizare" msprop:Generator_ColumnPropNameInRow="IDAngajatSalarizare" msprop:Generator_ColumnPropNameInTable="IDAngajatSalarizareColumn" msprop:Generator_UserColumnName="IDAngajatSalarizare" type="xs:int" />
              <xs:element name="IdPersoana" msprop:Generator_ColumnVarNameInTable="columnIdPersoana" msprop:Generator_ColumnPropNameInRow="IdPersoana" msprop:Generator_ColumnPropNameInTable="IdPersoanaColumn" msprop:Generator_UserColumnName="IdPersoana" type="xs:int" />
              <xs:element name="DeLaData" msprop:Generator_ColumnVarNameInTable="columnDeLaData" msprop:Generator_ColumnPropNameInRow="DeLaData" msprop:Generator_ColumnPropNameInTable="DeLaDataColumn" msprop:Generator_UserColumnName="DeLaData" type="xs:dateTime" />
              <xs:element name="Salar" msprop:Generator_ColumnVarNameInTable="columnSalar" msprop:Generator_ColumnPropNameInRow="Salar" msprop:Generator_ColumnPropNameInTable="SalarColumn" msprop:Generator_UserColumnName="Salar" type="xs:int" />
              <xs:element name="IDDepartament" msprop:Generator_ColumnVarNameInTable="columnIDDepartament" msprop:Generator_ColumnPropNameInRow="IDDepartament" msprop:Generator_ColumnPropNameInTable="IDDepartamentColumn" msprop:Generator_UserColumnName="IDDepartament" type="xs:int" />
              <xs:element name="IdTipGrad" msprop:Generator_ColumnVarNameInTable="columnIdTipGrad" msprop:Generator_ColumnPropNameInRow="IdTipGrad" msprop:Generator_ColumnPropNameInTable="IdTipGradColumn" msprop:Generator_UserColumnName="IdTipGrad" type="xs:int" />
              <xs:element name="OreNorma" msprop:Generator_ColumnVarNameInTable="columnOreNorma" msprop:Generator_ColumnPropNameInRow="OreNorma" msprop:Generator_ColumnPropNameInTable="OreNormaColumn" msprop:Generator_UserColumnName="OreNorma" type="xs:short" />
              <xs:element name="FractiuneNorma" msprop:Generator_ColumnVarNameInTable="columnFractiuneNorma" msprop:Generator_ColumnPropNameInRow="FractiuneNorma" msprop:Generator_ColumnPropNameInTable="FractiuneNormaColumn" msprop:Generator_UserColumnName="FractiuneNorma" type="xs:decimal" />
              <xs:element name="PanaLaData" msprop:Generator_ColumnVarNameInTable="columnPanaLaData" msprop:Generator_ColumnPropNameInRow="PanaLaData" msprop:Generator_ColumnPropNameInTable="PanaLaDataColumn" msprop:Generator_UserColumnName="PanaLaData" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NormaBaza" msprop:Generator_ColumnVarNameInTable="columnNormaBaza" msprop:Generator_ColumnPropNameInRow="NormaBaza" msprop:Generator_ColumnPropNameInTable="NormaBazaColumn" msprop:Generator_UserColumnName="NormaBaza" type="xs:boolean" />
              <xs:element name="ServiciiPeChitanta" msprop:Generator_ColumnVarNameInTable="columnServiciiPeChitanta" msprop:Generator_ColumnPropNameInRow="ServiciiPeChitanta" msprop:Generator_ColumnPropNameInTable="ServiciiPeChitantaColumn" msprop:Generator_UserColumnName="ServiciiPeChitanta" type="xs:boolean" minOccurs="0" />
              <xs:element name="CodUnitate" msprop:Generator_ColumnVarNameInTable="columnCodUnitate" msprop:Generator_ColumnPropNameInRow="CodUnitate" msprop:Generator_ColumnPropNameInTable="CodUnitateColumn" msprop:Generator_UserColumnName="CodUnitate" type="xs:short" />
              <xs:element name="Clasa" msprop:Generator_ColumnVarNameInTable="columnClasa" msprop:Generator_ColumnPropNameInRow="Clasa" msprop:Generator_ColumnPropNameInTable="ClasaColumn" msprop:Generator_UserColumnName="Clasa" type="xs:short" />
              <xs:element name="Grupa" msprop:Generator_ColumnVarNameInTable="columnGrupa" msprop:Generator_ColumnPropNameInRow="Grupa" msprop:Generator_ColumnPropNameInTable="GrupaColumn" msprop:Generator_UserColumnName="Grupa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDJurnal" msprop:Generator_ColumnVarNameInTable="columnIDJurnal" msprop:Generator_ColumnPropNameInRow="IDJurnal" msprop:Generator_ColumnPropNameInTable="IDJurnalColumn" msprop:Generator_UserColumnName="IDJurnal" type="xs:int" minOccurs="0" />
              <xs:element name="SalarFunctie" msprop:Generator_ColumnVarNameInTable="columnSalarFunctie" msprop:Generator_ColumnPropNameInRow="SalarFunctie" msprop:Generator_ColumnPropNameInTable="SalarFunctieColumn" msprop:Generator_UserColumnName="SalarFunctie" type="xs:decimal" />
              <xs:element name="Marca" msprop:Generator_ColumnVarNameInTable="columnMarca" msprop:Generator_ColumnPropNameInRow="Marca" msprop:Generator_ColumnPropNameInTable="MarcaColumn" msprop:Generator_UserColumnName="Marca" type="xs:int" minOccurs="0" />
              <xs:element name="NrContract" msprop:Generator_ColumnVarNameInTable="columnNrContract" msprop:Generator_ColumnPropNameInRow="NrContract" msprop:Generator_ColumnPropNameInTable="NrContractColumn" msprop:Generator_UserColumnName="NrContract" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DataContract" msprop:Generator_ColumnVarNameInTable="columnDataContract" msprop:Generator_ColumnPropNameInRow="DataContract" msprop:Generator_ColumnPropNameInTable="DataContractColumn" msprop:Generator_UserColumnName="DataContract" type="xs:dateTime" minOccurs="0" />
              <xs:element name="TipContract" msprop:Generator_ColumnVarNameInTable="columnTipContract" msprop:Generator_ColumnPropNameInRow="TipContract" msprop:Generator_ColumnPropNameInTable="TipContractColumn" msprop:Generator_UserColumnName="TipContract" type="xs:int" minOccurs="0" />
              <xs:element name="PerioadaDeterminata" msprop:Generator_ColumnVarNameInTable="columnPerioadaDeterminata" msprop:Generator_ColumnPropNameInRow="PerioadaDeterminata" msprop:Generator_ColumnPropNameInTable="PerioadaDeterminataColumn" msprop:Generator_UserColumnName="PerioadaDeterminata" type="xs:boolean" minOccurs="0" />
              <xs:element name="Observatii" msprop:Generator_ColumnVarNameInTable="columnObservatii" msprop:Generator_ColumnPropNameInRow="Observatii" msprop:Generator_ColumnPropNameInTable="ObservatiiColumn" msprop:Generator_UserColumnName="Observatii" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DurataContract" msprop:Generator_ColumnVarNameInTable="columnDurataContract" msprop:Generator_ColumnPropNameInRow="DurataContract" msprop:Generator_ColumnPropNameInTable="DurataContractColumn" msprop:Generator_UserColumnName="DurataContract" type="xs:double" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Persoane" msprop:Generator_TableClassName="PersoaneDataTable" msprop:Generator_TableVarName="tablePersoane" msprop:Generator_RowChangedName="PersoaneRowChanged" msprop:Generator_TablePropName="Persoane" msprop:Generator_RowDeletingName="PersoaneRowDeleting" msprop:Generator_RowChangingName="PersoaneRowChanging" msprop:Generator_RowEvHandlerName="PersoaneRowChangeEventHandler" msprop:Generator_RowDeletedName="PersoaneRowDeleted" msprop:Generator_RowClassName="PersoaneRow" msprop:Generator_UserTableName="Persoane" msprop:Generator_RowEvArgName="PersoaneRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdPersoana" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIdPersoana" msprop:Generator_ColumnPropNameInRow="IdPersoana" msprop:Generator_ColumnPropNameInTable="IdPersoanaColumn" msprop:Generator_UserColumnName="IdPersoana" type="xs:int" />
              <xs:element name="NumePrenume" msprop:Generator_ColumnVarNameInTable="columnNumePrenume" msprop:Generator_ColumnPropNameInRow="NumePrenume" msprop:Generator_ColumnPropNameInTable="NumePrenumeColumn" msprop:Generator_UserColumnName="NumePrenume">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nume_Anterior" msprop:Generator_ColumnVarNameInTable="columnNume_Anterior" msprop:Generator_ColumnPropNameInRow="Nume_Anterior" msprop:Generator_ColumnPropNameInTable="Nume_AnteriorColumn" msprop:Generator_UserColumnName="Nume_Anterior" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cnp" msprop:Generator_ColumnVarNameInTable="columnCnp" msprop:Generator_ColumnPropNameInRow="Cnp" msprop:Generator_ColumnPropNameInTable="CnpColumn" msprop:Generator_UserColumnName="Cnp" type="xs:decimal" />
              <xs:element name="Sex" msprop:Generator_ColumnVarNameInTable="columnSex" msprop:Generator_ColumnPropNameInRow="Sex" msprop:Generator_ColumnPropNameInTable="SexColumn" msprop:Generator_UserColumnName="Sex" type="xs:short" />
              <xs:element name="DataNasterii" msprop:Generator_ColumnVarNameInTable="columnDataNasterii" msprop:Generator_ColumnPropNameInRow="DataNasterii" msprop:Generator_ColumnPropNameInTable="DataNasteriiColumn" msprop:Generator_UserColumnName="DataNasterii" type="xs:dateTime" />
              <xs:element name="IDLocNastere" msprop:Generator_ColumnVarNameInTable="columnIDLocNastere" msprop:Generator_ColumnPropNameInRow="IDLocNastere" msprop:Generator_ColumnPropNameInTable="IDLocNastereColumn" msprop:Generator_UserColumnName="IDLocNastere" type="xs:int" />
              <xs:element name="TipAI" msprop:Generator_ColumnVarNameInTable="columnTipAI" msprop:Generator_ColumnPropNameInRow="TipAI" msprop:Generator_ColumnPropNameInTable="TipAIColumn" msprop:Generator_UserColumnName="TipAI" type="xs:short" />
              <xs:element name="SeriaAI" msprop:Generator_ColumnVarNameInTable="columnSeriaAI" msprop:Generator_ColumnPropNameInRow="SeriaAI" msprop:Generator_ColumnPropNameInTable="SeriaAIColumn" msprop:Generator_UserColumnName="SeriaAI">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumarAI" msprop:Generator_ColumnVarNameInTable="columnNumarAI" msprop:Generator_ColumnPropNameInRow="NumarAI" msprop:Generator_ColumnPropNameInTable="NumarAIColumn" msprop:Generator_UserColumnName="NumarAI">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DataElibAI" msprop:Generator_ColumnVarNameInTable="columnDataElibAI" msprop:Generator_ColumnPropNameInRow="DataElibAI" msprop:Generator_ColumnPropNameInTable="DataElibAIColumn" msprop:Generator_UserColumnName="DataElibAI" type="xs:dateTime" />
              <xs:element name="EmitentAI" msprop:Generator_ColumnVarNameInTable="columnEmitentAI" msprop:Generator_ColumnPropNameInRow="EmitentAI" msprop:Generator_ColumnPropNameInTable="EmitentAIColumn" msprop:Generator_UserColumnName="EmitentAI">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumeTata" msprop:Generator_ColumnVarNameInTable="columnNumeTata" msprop:Generator_ColumnPropNameInRow="NumeTata" msprop:Generator_ColumnPropNameInTable="NumeTataColumn" msprop:Generator_UserColumnName="NumeTata" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumeMama" msprop:Generator_ColumnVarNameInTable="columnNumeMama" msprop:Generator_ColumnPropNameInRow="NumeMama" msprop:Generator_ColumnPropNameInTable="NumeMamaColumn" msprop:Generator_UserColumnName="NumeMama" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StradaAdr" msprop:Generator_ColumnVarNameInTable="columnStradaAdr" msprop:Generator_ColumnPropNameInRow="StradaAdr" msprop:Generator_ColumnPropNameInTable="StradaAdrColumn" msprop:Generator_UserColumnName="StradaAdr">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDLocalitateAdr" msprop:Generator_ColumnVarNameInTable="columnIDLocalitateAdr" msprop:Generator_ColumnPropNameInRow="IDLocalitateAdr" msprop:Generator_ColumnPropNameInTable="IDLocalitateAdrColumn" msprop:Generator_UserColumnName="IDLocalitateAdr" type="xs:int" />
              <xs:element name="NrAdr" msprop:Generator_ColumnVarNameInTable="columnNrAdr" msprop:Generator_ColumnPropNameInRow="NrAdr" msprop:Generator_ColumnPropNameInTable="NrAdrColumn" msprop:Generator_UserColumnName="NrAdr">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BlocAdr" msprop:Generator_ColumnVarNameInTable="columnBlocAdr" msprop:Generator_ColumnPropNameInRow="BlocAdr" msprop:Generator_ColumnPropNameInTable="BlocAdrColumn" msprop:Generator_UserColumnName="BlocAdr">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EtajAdr" msprop:Generator_ColumnVarNameInTable="columnEtajAdr" msprop:Generator_ColumnPropNameInRow="EtajAdr" msprop:Generator_ColumnPropNameInTable="EtajAdrColumn" msprop:Generator_UserColumnName="EtajAdr" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ScaraAdr" msprop:Generator_ColumnVarNameInTable="columnScaraAdr" msprop:Generator_ColumnPropNameInRow="ScaraAdr" msprop:Generator_ColumnPropNameInTable="ScaraAdrColumn" msprop:Generator_UserColumnName="ScaraAdr" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ApartamentAdr" msprop:Generator_ColumnVarNameInTable="columnApartamentAdr" msprop:Generator_ColumnPropNameInRow="ApartamentAdr" msprop:Generator_ColumnPropNameInTable="ApartamentAdrColumn" msprop:Generator_UserColumnName="ApartamentAdr">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GradInvaliditate" msprop:Generator_ColumnVarNameInTable="columnGradInvaliditate" msprop:Generator_ColumnPropNameInRow="GradInvaliditate" msprop:Generator_ColumnPropNameInTable="GradInvaliditateColumn" msprop:Generator_UserColumnName="GradInvaliditate" type="xs:short" minOccurs="0" />
              <xs:element name="TelefonFix" msprop:Generator_ColumnVarNameInTable="columnTelefonFix" msprop:Generator_ColumnPropNameInRow="TelefonFix" msprop:Generator_ColumnPropNameInTable="TelefonFixColumn" msprop:Generator_UserColumnName="TelefonFix" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TelefonMobil" msprop:Generator_ColumnVarNameInTable="columnTelefonMobil" msprop:Generator_ColumnPropNameInRow="TelefonMobil" msprop:Generator_ColumnPropNameInTable="TelefonMobilColumn" msprop:Generator_UserColumnName="TelefonMobil">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Observatii" msprop:Generator_ColumnVarNameInTable="columnObservatii" msprop:Generator_ColumnPropNameInRow="Observatii" msprop:Generator_ColumnPropNameInTable="ObservatiiColumn" msprop:Generator_UserColumnName="Observatii" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumarCM" msprop:Generator_ColumnVarNameInTable="columnNumarCM" msprop:Generator_ColumnPropNameInRow="NumarCM" msprop:Generator_ColumnPropNameInTable="NumarCMColumn" msprop:Generator_UserColumnName="NumarCM">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SerieCM" msprop:Generator_ColumnVarNameInTable="columnSerieCM" msprop:Generator_ColumnPropNameInRow="SerieCM" msprop:Generator_ColumnPropNameInTable="SerieCMColumn" msprop:Generator_UserColumnName="SerieCM">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodUnitate" msprop:Generator_ColumnVarNameInTable="columnCodUnitate" msprop:Generator_ColumnPropNameInRow="CodUnitate" msprop:Generator_ColumnPropNameInTable="CodUnitateColumn" msprop:Generator_UserColumnName="CodUnitate" type="xs:short" />
              <xs:element name="NrFileCM" msprop:Generator_ColumnVarNameInTable="columnNrFileCM" msprop:Generator_ColumnPropNameInRow="NrFileCM" msprop:Generator_ColumnPropNameInTable="NrFileCMColumn" msprop:Generator_UserColumnName="NrFileCM" type="xs:short" />
              <xs:element name="NrCutieCM" msprop:Generator_ColumnVarNameInTable="columnNrCutieCM" msprop:Generator_ColumnPropNameInRow="NrCutieCM" msprop:Generator_ColumnPropNameInTable="NrCutieCMColumn" msprop:Generator_UserColumnName="NrCutieCM">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Marca" msprop:Generator_ColumnVarNameInTable="columnMarca" msprop:Generator_ColumnPropNameInRow="Marca" msprop:Generator_ColumnPropNameInTable="MarcaColumn" msprop:Generator_UserColumnName="Marca">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TelefonInterior" msprop:Generator_ColumnVarNameInTable="columnTelefonInterior" msprop:Generator_ColumnPropNameInRow="TelefonInterior" msprop:Generator_ColumnPropNameInTable="TelefonInteriorColumn" msprop:Generator_UserColumnName="TelefonInterior" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdCasaAsigSanatate" msprop:Generator_ColumnVarNameInTable="columnIdCasaAsigSanatate" msprop:Generator_ColumnPropNameInRow="IdCasaAsigSanatate" msprop:Generator_ColumnPropNameInTable="IdCasaAsigSanatateColumn" msprop:Generator_UserColumnName="IdCasaAsigSanatate" type="xs:short" />
              <xs:element name="IdTipStudii" msprop:Generator_ColumnVarNameInTable="columnIdTipStudii" msprop:Generator_ColumnPropNameInRow="IdTipStudii" msprop:Generator_ColumnPropNameInTable="IdTipStudiiColumn" msprop:Generator_UserColumnName="IdTipStudii" type="xs:int" />
              <xs:element name="DataVechimeMunca" msprop:Generator_ColumnVarNameInTable="columnDataVechimeMunca" msprop:Generator_ColumnPropNameInRow="DataVechimeMunca" msprop:Generator_ColumnPropNameInTable="DataVechimeMuncaColumn" msprop:Generator_UserColumnName="DataVechimeMunca" type="xs:dateTime" />
              <xs:element name="UserID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:string" minOccurs="0" />
              <xs:element name="PozCutieCM" msprop:Generator_ColumnVarNameInTable="columnPozCutieCM" msprop:Generator_ColumnPropNameInRow="PozCutieCM" msprop:Generator_ColumnPropNameInTable="PozCutieCMColumn" msprop:Generator_UserColumnName="PozCutieCM" type="xs:short" />
              <xs:element name="PlatesteCAS" msprop:Generator_ColumnVarNameInTable="columnPlatesteCAS" msprop:Generator_ColumnPropNameInRow="PlatesteCAS" msprop:Generator_ColumnPropNameInTable="PlatesteCASColumn" msprop:Generator_UserColumnName="PlatesteCAS" type="xs:boolean" />
              <xs:element name="PlatesteCASS" msprop:Generator_ColumnVarNameInTable="columnPlatesteCASS" msprop:Generator_ColumnPropNameInRow="PlatesteCASS" msprop:Generator_ColumnPropNameInTable="PlatesteCASSColumn" msprop:Generator_UserColumnName="PlatesteCASS" type="xs:boolean" />
              <xs:element name="PlatesteSomaj" msprop:Generator_ColumnVarNameInTable="columnPlatesteSomaj" msprop:Generator_ColumnPropNameInRow="PlatesteSomaj" msprop:Generator_ColumnPropNameInTable="PlatesteSomajColumn" msprop:Generator_UserColumnName="PlatesteSomaj" type="xs:boolean" />
              <xs:element name="PlatesteImpozit" msprop:Generator_ColumnVarNameInTable="columnPlatesteImpozit" msprop:Generator_ColumnPropNameInRow="PlatesteImpozit" msprop:Generator_ColumnPropNameInTable="PlatesteImpozitColumn" msprop:Generator_UserColumnName="PlatesteImpozit" type="xs:boolean" />
              <xs:element name="AreDeducere" msprop:Generator_ColumnVarNameInTable="columnAreDeducere" msprop:Generator_ColumnPropNameInRow="AreDeducere" msprop:Generator_ColumnPropNameInTable="AreDeducereColumn" msprop:Generator_UserColumnName="AreDeducere" type="xs:boolean" />
              <xs:element name="DataPlecarii" msprop:Generator_ColumnVarNameInTable="columnDataPlecarii" msprop:Generator_ColumnPropNameInRow="DataPlecarii" msprop:Generator_ColumnPropNameInTable="DataPlecariiColumn" msprop:Generator_UserColumnName="DataPlecarii" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MotivIncetareContract" msprop:Generator_ColumnVarNameInTable="columnMotivIncetareContract" msprop:Generator_ColumnPropNameInRow="MotivIncetareContract" msprop:Generator_ColumnPropNameInTable="MotivIncetareContractColumn" msprop:Generator_UserColumnName="MotivIncetareContract" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ResUmaSetup" msprop:Generator_TableClassName="ResUmaSetupDataTable" msprop:Generator_TableVarName="tableResUmaSetup" msprop:Generator_TablePropName="ResUmaSetup" msprop:Generator_RowDeletingName="ResUmaSetupRowDeleting" msprop:Generator_RowChangingName="ResUmaSetupRowChanging" msprop:Generator_RowEvHandlerName="ResUmaSetupRowChangeEventHandler" msprop:Generator_RowDeletedName="ResUmaSetupRowDeleted" msprop:Generator_UserTableName="ResUmaSetup" msprop:Generator_RowChangedName="ResUmaSetupRowChanged" msprop:Generator_RowEvArgName="ResUmaSetupRowChangeEvent" msprop:Generator_RowClassName="ResUmaSetupRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PrimaryKey" msprop:Generator_ColumnVarNameInTable="columnPrimaryKey" msprop:Generator_ColumnPropNameInRow="PrimaryKey" msprop:Generator_ColumnPropNameInTable="PrimaryKeyColumn" msprop:Generator_UserColumnName="PrimaryKey" type="xs:short" />
              <xs:element name="CodUnitate" msprop:Generator_ColumnVarNameInTable="columnCodUnitate" msprop:Generator_ColumnPropNameInRow="CodUnitate" msprop:Generator_ColumnPropNameInTable="CodUnitateColumn" msprop:Generator_UserColumnName="CodUnitate" type="xs:short" />
              <xs:element name="AnulCurent" msprop:Generator_ColumnVarNameInTable="columnAnulCurent" msprop:Generator_ColumnPropNameInRow="AnulCurent" msprop:Generator_ColumnPropNameInTable="AnulCurentColumn" msprop:Generator_UserColumnName="AnulCurent" type="xs:short" />
              <xs:element name="LunaCurenta" msprop:Generator_ColumnVarNameInTable="columnLunaCurenta" msprop:Generator_ColumnPropNameInRow="LunaCurenta" msprop:Generator_ColumnPropNameInTable="LunaCurentaColumn" msprop:Generator_UserColumnName="LunaCurenta" type="xs:short" />
              <xs:element name="PropagaModificari" msprop:Generator_ColumnVarNameInTable="columnPropagaModificari" msprop:Generator_ColumnPropNameInRow="PropagaModificari" msprop:Generator_ColumnPropNameInTable="PropagaModificariColumn" msprop:Generator_UserColumnName="PropagaModificari" type="xs:boolean" />
              <xs:element name="Contracte" msprop:Generator_ColumnVarNameInTable="columnContracte" msprop:Generator_ColumnPropNameInRow="Contracte" msprop:Generator_ColumnPropNameInTable="ContracteColumn" msprop:Generator_UserColumnName="Contracte" type="xs:boolean" />
              <xs:element name="ProcentCASAngajator" msprop:Generator_ColumnVarNameInTable="columnProcentCASAngajator" msprop:Generator_ColumnPropNameInRow="ProcentCASAngajator" msprop:Generator_ColumnPropNameInTable="ProcentCASAngajatorColumn" msprop:Generator_UserColumnName="ProcentCASAngajator" type="xs:decimal" />
              <xs:element name="SalarMinim" msprop:Generator_ColumnVarNameInTable="columnSalarMinim" msprop:Generator_ColumnPropNameInRow="SalarMinim" msprop:Generator_ColumnPropNameInTable="SalarMinimColumn" msprop:Generator_UserColumnName="SalarMinim" type="xs:decimal" />
              <xs:element name="SalarMediuBrut" msprop:Generator_ColumnVarNameInTable="columnSalarMediuBrut" msprop:Generator_ColumnPropNameInRow="SalarMediuBrut" msprop:Generator_ColumnPropNameInTable="SalarMediuBrutColumn" msprop:Generator_UserColumnName="SalarMediuBrut" type="xs:decimal" />
              <xs:element name="NrSalariiMaxCAS" msprop:Generator_ColumnVarNameInTable="columnNrSalariiMaxCAS" msprop:Generator_ColumnPropNameInRow="NrSalariiMaxCAS" msprop:Generator_ColumnPropNameInTable="NrSalariiMaxCASColumn" msprop:Generator_UserColumnName="NrSalariiMaxCAS" type="xs:short" />
              <xs:element name="ProcentCASAngajat" msprop:Generator_ColumnVarNameInTable="columnProcentCASAngajat" msprop:Generator_ColumnPropNameInRow="ProcentCASAngajat" msprop:Generator_ColumnPropNameInTable="ProcentCASAngajatColumn" msprop:Generator_UserColumnName="ProcentCASAngajat" type="xs:decimal" />
              <xs:element name="PlafonareCAS" msprop:Generator_ColumnVarNameInTable="columnPlafonareCAS" msprop:Generator_ColumnPropNameInRow="PlafonareCAS" msprop:Generator_ColumnPropNameInTable="PlafonareCASColumn" msprop:Generator_UserColumnName="PlafonareCAS" type="xs:boolean" />
              <xs:element name="ProcentSomajAngajat" msprop:Generator_ColumnVarNameInTable="columnProcentSomajAngajat" msprop:Generator_ColumnPropNameInRow="ProcentSomajAngajat" msprop:Generator_ColumnPropNameInTable="ProcentSomajAngajatColumn" msprop:Generator_UserColumnName="ProcentSomajAngajat" type="xs:decimal" />
              <xs:element name="ProcentSomajAngajator" msprop:Generator_ColumnVarNameInTable="columnProcentSomajAngajator" msprop:Generator_ColumnPropNameInRow="ProcentSomajAngajator" msprop:Generator_ColumnPropNameInTable="ProcentSomajAngajatorColumn" msprop:Generator_UserColumnName="ProcentSomajAngajator" type="xs:decimal" />
              <xs:element name="ProcentASSAngajat" msprop:Generator_ColumnVarNameInTable="columnProcentASSAngajat" msprop:Generator_ColumnPropNameInRow="ProcentASSAngajat" msprop:Generator_ColumnPropNameInTable="ProcentASSAngajatColumn" msprop:Generator_UserColumnName="ProcentASSAngajat" type="xs:decimal" />
              <xs:element name="ProcentASSAngajator" msprop:Generator_ColumnVarNameInTable="columnProcentASSAngajator" msprop:Generator_ColumnPropNameInRow="ProcentASSAngajator" msprop:Generator_ColumnPropNameInTable="ProcentASSAngajatorColumn" msprop:Generator_UserColumnName="ProcentASSAngajator" type="xs:decimal" />
              <xs:element name="ScanRes" msprop:Generator_ColumnVarNameInTable="columnScanRes" msprop:Generator_ColumnPropNameInRow="ScanRes" msprop:Generator_ColumnPropNameInTable="ScanResColumn" msprop:Generator_UserColumnName="ScanRes" type="xs:int" minOccurs="0" />
              <xs:element name="OrizExtent" msprop:Generator_ColumnVarNameInTable="columnOrizExtent" msprop:Generator_ColumnPropNameInRow="OrizExtent" msprop:Generator_ColumnPropNameInTable="OrizExtentColumn" msprop:Generator_UserColumnName="OrizExtent" type="xs:int" minOccurs="0" />
              <xs:element name="VertExtent" msprop:Generator_ColumnVarNameInTable="columnVertExtent" msprop:Generator_ColumnPropNameInRow="VertExtent" msprop:Generator_ColumnPropNameInTable="VertExtentColumn" msprop:Generator_UserColumnName="VertExtent" type="xs:int" minOccurs="0" />
              <xs:element name="ColorFormat" msprop:Generator_ColumnVarNameInTable="columnColorFormat" msprop:Generator_ColumnPropNameInRow="ColorFormat" msprop:Generator_ColumnPropNameInTable="ColorFormatColumn" msprop:Generator_UserColumnName="ColorFormat" type="xs:int" minOccurs="0" />
              <xs:element name="ScanDebug" msprop:Generator_ColumnVarNameInTable="columnScanDebug" msprop:Generator_ColumnPropNameInRow="ScanDebug" msprop:Generator_ColumnPropNameInTable="ScanDebugColumn" msprop:Generator_UserColumnName="ScanDebug" type="xs:boolean" minOccurs="0" />
              <xs:element name="VersiuneCOR" msprop:Generator_ColumnVarNameInTable="columnVersiuneCOR" msprop:Generator_ColumnPropNameInRow="VersiuneCOR" msprop:Generator_ColumnPropNameInTable="VersiuneCORColumn" msprop:Generator_UserColumnName="VersiuneCOR" type="xs:short" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="AngajatiGarzi" msprop:Generator_TableClassName="AngajatiGarziDataTable" msprop:Generator_TableVarName="tableAngajatiGarzi" msprop:Generator_TablePropName="AngajatiGarzi" msprop:Generator_RowDeletingName="AngajatiGarziRowDeleting" msprop:Generator_RowChangingName="AngajatiGarziRowChanging" msprop:Generator_RowEvHandlerName="AngajatiGarziRowChangeEventHandler" msprop:Generator_RowDeletedName="AngajatiGarziRowDeleted" msprop:Generator_UserTableName="AngajatiGarzi" msprop:Generator_RowChangedName="AngajatiGarziRowChanged" msprop:Generator_RowEvArgName="AngajatiGarziRowChangeEvent" msprop:Generator_RowClassName="AngajatiGarziRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDGarda" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDGarda" msprop:Generator_ColumnPropNameInRow="IDGarda" msprop:Generator_ColumnPropNameInTable="IDGardaColumn" msprop:Generator_UserColumnName="IDGarda" type="xs:int" />
              <xs:element name="CodUnitate" msprop:Generator_ColumnVarNameInTable="columnCodUnitate" msprop:Generator_ColumnPropNameInRow="CodUnitate" msprop:Generator_ColumnPropNameInTable="CodUnitateColumn" msprop:Generator_UserColumnName="CodUnitate" type="xs:short" />
              <xs:element name="Luna" msprop:Generator_ColumnVarNameInTable="columnLuna" msprop:Generator_ColumnPropNameInRow="Luna" msprop:Generator_ColumnPropNameInTable="LunaColumn" msprop:Generator_UserColumnName="Luna" type="xs:short" />
              <xs:element name="Anul" msprop:Generator_ColumnVarNameInTable="columnAnul" msprop:Generator_ColumnPropNameInRow="Anul" msprop:Generator_ColumnPropNameInTable="AnulColumn" msprop:Generator_UserColumnName="Anul" type="xs:short" />
              <xs:element name="IDPersoana" msprop:Generator_ColumnVarNameInTable="columnIDPersoana" msprop:Generator_ColumnPropNameInRow="IDPersoana" msprop:Generator_ColumnPropNameInTable="IDPersoanaColumn" msprop:Generator_UserColumnName="IDPersoana" type="xs:int" />
              <xs:element name="IDAngajatSalarizare" msprop:Generator_ColumnVarNameInTable="columnIDAngajatSalarizare" msprop:Generator_ColumnPropNameInRow="IDAngajatSalarizare" msprop:Generator_ColumnPropNameInTable="IDAngajatSalarizareColumn" msprop:Generator_UserColumnName="IDAngajatSalarizare" type="xs:int" />
              <xs:element name="StartGarda" msprop:Generator_ColumnVarNameInTable="columnStartGarda" msprop:Generator_ColumnPropNameInRow="StartGarda" msprop:Generator_ColumnPropNameInTable="StartGardaColumn" msprop:Generator_UserColumnName="StartGarda" type="xs:dateTime" />
              <xs:element name="EndGarda" msprop:Generator_ColumnVarNameInTable="columnEndGarda" msprop:Generator_ColumnPropNameInRow="EndGarda" msprop:Generator_ColumnPropNameInTable="EndGardaColumn" msprop:Generator_UserColumnName="EndGarda" type="xs:dateTime" />
              <xs:element name="IDAngajatInlocuit" msprop:Generator_ColumnVarNameInTable="columnIDAngajatInlocuit" msprop:Generator_ColumnPropNameInRow="IDAngajatInlocuit" msprop:Generator_ColumnPropNameInTable="IDAngajatInlocuitColumn" msprop:Generator_UserColumnName="IDAngajatInlocuit" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:AngajatiSalarizare" />
      <xs:field xpath="mstns:IDAngajatSalarizare" />
    </xs:unique>
    <xs:unique name="Persoane_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Persoane" />
      <xs:field xpath="mstns:IdPersoana" />
    </xs:unique>
    <xs:unique name="ResUmaSetup_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ResUmaSetup" />
      <xs:field xpath="mstns:PrimaryKey" />
      <xs:field xpath="mstns:CodUnitate" />
    </xs:unique>
    <xs:unique name="AngajatiGarzi_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:AngajatiGarzi" />
      <xs:field xpath="mstns:IDGarda" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_AngajatiSalarizare_Persoane" msdata:parent="Persoane" msdata:child="AngajatiSalarizare" msdata:parentkey="IdPersoana" msdata:childkey="IdPersoana" msprop:Generator_UserChildTable="AngajatiSalarizare" msprop:Generator_ChildPropName="GetAngajatiSalarizareRows" msprop:Generator_UserRelationName="FK_AngajatiSalarizare_Persoane" msprop:Generator_ParentPropName="PersoaneRow" msprop:Generator_RelationVarName="relationFK_AngajatiSalarizare_Persoane" msprop:Generator_UserParentTable="Persoane" />
      <msdata:Relationship name="FK_AngajatiGarzi_AngajatiSalarizare" msdata:parent="AngajatiSalarizare" msdata:child="AngajatiGarzi" msdata:parentkey="IDAngajatSalarizare" msdata:childkey="IDAngajatSalarizare" msprop:Generator_UserChildTable="AngajatiGarzi" msprop:Generator_ChildPropName="GetAngajatiGarziRowsByFK_AngajatiGarzi_AngajatiSalarizare" msprop:Generator_UserRelationName="FK_AngajatiGarzi_AngajatiSalarizare" msprop:Generator_ParentPropName="AngajatiSalarizareRowByFK_AngajatiGarzi_AngajatiSalarizare" msprop:Generator_RelationVarName="relationFK_AngajatiGarzi_AngajatiSalarizare" msprop:Generator_UserParentTable="AngajatiSalarizare" />
      <msdata:Relationship name="FK_AngajatiGarzi_AngajatiSalarizare1" msdata:parent="AngajatiSalarizare" msdata:child="AngajatiGarzi" msdata:parentkey="IDAngajatSalarizare" msdata:childkey="IDAngajatInlocuit" msprop:Generator_UserChildTable="AngajatiGarzi" msprop:Generator_ChildPropName="GetAngajatiGarziRowsByFK_AngajatiGarzi_AngajatiSalarizare1" msprop:Generator_UserRelationName="FK_AngajatiGarzi_AngajatiSalarizare1" msprop:Generator_ParentPropName="AngajatiSalarizareRowByFK_AngajatiGarzi_AngajatiSalarizare1" msprop:Generator_RelationVarName="relationFK_AngajatiGarzi_AngajatiSalarizare1" msprop:Generator_UserParentTable="AngajatiSalarizare" />
      <msdata:Relationship name="FK_AngajatiGarzi_Persoane" msdata:parent="Persoane" msdata:child="AngajatiGarzi" msdata:parentkey="IdPersoana" msdata:childkey="IDPersoana" msprop:Generator_UserChildTable="AngajatiGarzi" msprop:Generator_ChildPropName="GetAngajatiGarziRows" msprop:Generator_UserRelationName="FK_AngajatiGarzi_Persoane" msprop:Generator_ParentPropName="PersoaneRow" msprop:Generator_RelationVarName="relationFK_AngajatiGarzi_Persoane" msprop:Generator_UserParentTable="Persoane" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>